package se.peterbjorkman.android.trafikkamera.providers;

abstract class DatabaseDefs {
	protected DatabaseDefs() throws Exception{
		throw new Exception("DatabaseDefs can not be instansiated.");
	}
	
	public static final String ID = "_id";
	public static final String NAME = "Name";
	public static final String COUNTY = "County";
	public static final String ROAD = "Road";
	public static final String DESCRIPTION = "Description";
	public static final String CAMERA_URL = "CameraURl";
	public static final String MAP_URL = "MapUrl";
	public static final String LONGITUDE = "Longitude";
	public static final String LATITUDE = "Latitude";
	public static final String FAVORITE = "Favorite";
	public static final String EXTID = "ExtId";
	public static final String CAMERA_URL_SMALL = "CameraUrlSmall";
	public static final String NICKNAME = "Nickname";
	
	public static final String ROUTEID = "routeid";
	public static final String CAMERAID = "cameraid";
	public static final String SORTORDER = "sortorder";
	
	public static final String DATABASE_NAME = "cameras.db";
	public static final int DATABASE_VERSION = 3; // TODO Database versioon
	public static final String CAMERAS_TABLE_NAME = "cameras";
	public static final String COUNTY_TABLE_NAME = "counties";
	public static final String ROUTES_TABLE_NAME = "routes";
	public static final String CAMERASINROUTE_TABLE_NAME = "camerasinroutes";
}
